package com.pic.mgt.dao.syushin;

import java.sql.Timestamp;
import java.util.Date;

import org.springframework.dao.DataAccessException;

import com.pic.mgt.dao.IBasicDao;

public interface ISyushinBucketMgtDao extends IBasicDao {
	// table 內的欄位名稱
	public static final String _bucketFilename = "bucket_file_name";
	public static final String _bucketTime = "bucket_time";
	public static final String _businessName = "business_name";
	public static final String _bucketNo = "bucket_no";
	public static final String _batchFileAmount = "batch_file_amount";
	public static final String _creatingTime = "creating_time";
	
	public int updateBucketTimeAndBatchFileAmountByBucketFilename(Timestamp bucketTime, int batchFileAmount, String bucketFilename) throws DataAccessException;
	
	public int updateCreatingTimeByBucketFilename(Date creatingTime, String bucketFilename) throws DataAccessException;
	
	public SyushinBucketMgtInfoBean findSyushinBucketMgtInfoByBucketFilename(String bucketFilename) throws DataAccessException;
}
